2013-04-29 - 5956.200 - Rel Notes -ROC Enhancements - Customer Segmentation Package. #DotNetReleases2013

Release Notes

5956.200 - Spec -ROC Enhancements.

Admin Info

Purpose
 Populate tblCustCollection, tblCustSegmentation tables
Release No#
 001
Submitted on
 04/29/2013
Submitted by
 Venkat A
Source/Destination Systems
 Local/NEC DEV
Release Sent To
 Bibin
Objects Created By
 Venkat A
Objects Tested By
 Venkat A

Transport and Technical Objects

Location Objects Name
  • CustCollection.dtsx
  • CustSegmentation.dtsx
  • CustSegmentation.sql

Release Notes

For Infrastructure


Run the Sql Script from the above location on Dev DB

For Requestor


Test Notes

Title
Module
Steps
Expected Result
Result
1)CustCollection.dtsx
 CustCollection.dtsx
  1. Execute the CustCollection package.
  2. Check the data in CSV with data populated in the table.
  3. Also check for the date condition(today date should fall between start and end date).
  1. New data has to be populated into the table.
  2. Date condition also need to be satisfied.
 1. All the data will be populated into the table which satisfies the date condition.
2. Last Update date time for new data should be today's date
.
2)CustSegmentation.dtsx
 CustSegmentation.dtsx
  1. Execute theCustSegmentation package.
  2. Check the data in CSV with data populated in the table.
  3. Also check for the date condition(today date should fall between start and end date).
  1. New data has to be populated into the table.
  2. Date condition also need to be satisfied.
 1. All the data will be populated into the table which satisfies the date condition.
2. Last Update date time for new data should be today's date

Reference Document (Specifications or Production Support Break Fix)

5956.200 - Spec -ROC Enhancements - Customer Segmentation Package